'use strict';

module.exports = app => {
  const { STRING, INTEGER } = app.Sequelize;

  const Finance = app.model.define('finance', {
    id: { type: INTEGER, primaryKey: true, autoIncrement: true },
    cid: STRING,
    company: STRING,
    higher: STRING,
    lower: STRING,
    type: STRING,
    amount: STRING,
    finished: INTEGER,
    arrear: STRING,
    invoice: STRING,
    fid: STRING,
    claimer: STRING,
    mark: STRING,
    time: STRING,
  });

  return Finance;
};
